import csv
import sqlite3

connection = sqlite3.connect('../db.sqlite3')
cursor = connection.cursor()

create_table = '''
create table data_Power
(
    Name text not null,
    ID text not null,
    PID text not null,
    Platform text not null,
    Price text,
    Power text,
    Authentication text,
    Color text,
    ModType text,
    constraint power_pk
        primary key (Name,ID,PID,Platform)
);

'''

cursor.execute(create_table)
file = open('../GetInfo/Details/PowerInfo.csv', encoding='utf-8')
contents = csv.reader(file)
insert_records = "INSERT INTO data_Power (Name,ID,PID,Platform,Price,Power,Authentication,Color,ModType) " \
                 "VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)"

cursor.executemany(insert_records, contents)
select_all = "SELECT * FROM data_Power"
rows = cursor.execute(select_all).fetchall()
for r in rows:
    print(r)

# Committing the changes
connection.commit()
connection.close()
